When you export data from SAS Enterprise Guide to XLSX, the data might be incorrectly converted when the data begins with "_x" followed by a four-digit number or letters (from "a" to "f"), and ends with an ASCII code (hexadecimal representation from "21" to "2F" or from "3B" to "40").

For example, suppose that you are exporting the following data to XLSX by clicking on Export:

The exported data might be incorrectly converted to this:

The following workarounds are available for SAS Enterprise Guide:

• Export to XLS format.
• Export to CSV format.
• Use Send to Microsoft Excel instead of Export.
• Use PROC EXPORT dbms=XLSX (SAS/ACCESS^® Interface to PC Files is required).
• Use ODS EXCEL (or select the Excel results format in Tools ► Options ► Results), and run a PROC PRINT NOOBS; RUN; to create a native XLSX file.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Enterprise Guide 8.1 is available at:

A fix for this issue for SAS Add-In for Microsoft Office 8.1 is available at:

A fix for this issue for SAS Visual Analytics Add-In for Office 8.1 is available at: